Configuring EPO to use the new version of the PostgreSQL database

This section describes the steps to configure EPO to use the new PostgreSQL version. Complete installing and upgrading PostgreSQL database before proceeding to the following steps.

To configure EPO to use the new PostgreSQL version:

  1. From the Service application or command prompt, stop the older version of PostgreSQL service.
  2. Navigate to the potgreSQL.conf file, and update port number from 5433 to 5432. The postgresql.conf file can be found in the following directory:

    .:\Program Files\postgreSQL\14\data
  3. From the default install location copy the content of the ‘data’ directory for the latest version located in the following path: .:\Program Files\postgreSQL\14\data
  4. Paste the content to the data directory referenced by EPO, located in the following path:

    .. \ProgramData\Schneider Electric\Power Operation\v20XX\database
  5. From Service application or command prompt, start the new PostgreSQL service.
  6. Uninstall the previous version of PostgreSQL from the computer.
  7. Reset the Internet Information Service (IIS) and restart the Application Pool.
  8. Login with any other user account with EPO access.
  9. Run the EPO project. Data flows to the new version of PostgreSQL database installed on the computer.

Additional Workflows

This section has additional workflows that can be referenced, if necessary.

To upgrade the PostgreSQL version in the computer running EPO:

  1. Using File explorer, access the folder where PostgreSQL is installed. For example: .:\Program Files
  2. Right-click the PostgreSQL folder and click Properties.
  3. Select the Security tab.
  4. Search and select the user requiring access from the list.
  5. Click Edit and select Full control.
  6. Click Apply and OK to grant full control access for the specific user selected as shown.

To reset IIS:

  1. Click the Windows Start icon and type cmd in the search box.
  2. Right-click the cmd.exe and select Run as administrator. A command prompt window opens.
  3. From the command prompt, type IISRESET, and press <Enter>.
  4. Exit after the ‘Internet services successfully restarted’ message displays.

To restart the Application Pool:

  1. Click the Windows Start icon and type IIS in the search box.
  2. Select Run as administrator. IIS Manager window is displayed.
  3. Click Application Pools.
  4. Right-click WebHmiAppPool and select Stop.
  5. Right-click WebHmiAppPool and select Start.
  6. Repeat steps 4 and 5 for DefaultAppPool, PsoWebServiceAppPool and PlatformServerAppPool.